SQL Tutorial Home

How to Remove a Default Value From a Column in MS-SQL

To remove the default constraint from a table, use alter table with drop constraint as shown in the example:

alter table employee drop constraint last_bonus_default;